2014-07-09 - 12644.200 - Break Fix - Analysis Datasource Standardization #AnalysisTool

Break Fix

12644.200 - Analysis Datasource Standardization

Problem Summary

Cleanup project for Analysis datasources that includes the following activities:
1. Renaming key figures and dimensions for consistency including abbreviations and case.
2. Adding fields to datasources wherever applicable.
3. Add parameter options wherever applicable.

Admin Info

Purpose	Analysis Datasource Standardization
Requested by	Mark Grzechowiak
Issue Date	07-09-2014
Resolved by	Praveen Guntuka
Resolved Date	07-09-2014
Document Status	Complete

References

Prior Tickets

13257.400

Documents

Datasource_cleanup_final.docx

Detailed Problem Description

1. Need to rename key figures and dimensions for consistency including abbreviations and case.
2. Need to add fields to datasources wherever applicable.
3. Need to add parameter options wherever applicable.

Mail from Ashwin on 07/09/2014 :

Add below queries to the document
1. VMP_OOCON_Q001
2. VMP_OPASA_Q005

IM from Ashwin on 07/09/2014 :
Prompt order should be as below
Year
Region
Currency
and rest of them in Alphabetical Order
Mandatory prompts show by default in Alphabetical order and rest of then need to show after Mandatory prompts.

Solution Analysis and Recommendations

Resolution

Need to follow the 'Datasource_Cleanup' document to add or modify the following sections of analysis datasources:
1. Datasources.
2. Dimensions.
3. Key figures.
4. Database fields.
5. Parameters.

Release Information

None